Skip to main content

Overtime after 40 hrs

Follows US Federal FLSA overtime pay for 1.5times regular pay when working greater than 40hours in a 7 day workweek.

Details

Rule Type
Time

Execution
After segment

Parameters

NameDataTypeDefaultValueDescription

Decision Tree

Rule processing begins in the cell R1:Level1 and proceeds right/down. Any IF statement which results in a DONE step terminates the rule immediately.

Line#Level1Level2Level3Comment
1Start
2IF(EMPLOYEE(Exempt) = 1) Not allowed if the employee is Exempt
3DONE
4IF(CALC(REG:week) > 40) Do we have weekly hours past 40?
5SET(hours_over = SUBTRACT(CALC(REG:week), 40.0))Calculate the number of hours > 40 for the week and place in temporary variable
6SET(RegularHours = SUBTRACT(RegularHours, hours_over))Subtract the overage from REG
7SET(OTHours = hours_over)Set OT to the overage
8DONE